SELECT
concat( "", d.demographic_no, "" ) as 'Chart Number',
CONCAT(d.last_name,', ', d.first_name) as 'Patient Name',
CONCAT(date_of_birth, '-', month_of_birth, '-',year_of_birth, ' ') as 'Date of Birth',
CONCAT(' Home: ', d.phone, ' Work: ' , d.phone2) as 'Phone Numbers',
CONCAT( "", "eChart", "" ) AS "eChart",
e.timeStamp,
SUBSTRING(e.Reminders, LOCATE('{searchtext}', e.Reminders), 50) AS SearchTerm,
e.Reminders AS REMINDER
FROM demographic d
JOIN (
SELECT ac.demographicNo, MAX(ac.eChartId) AS 'eChartId'
FROM eChart ac
GROUP BY ac.demographicNo
) AS aggrChart ON d.demographic_no = aggrChart.demographicNo
JOIN eChart e ON e.eChartId = aggrChart.eChartId
WHERE d.patient_status = 'AC'
AND e.Reminders like '%{searchtext}%'
ORDER by e.timeStamp DESC